| AdEnroll_Proxy |
| EntityType | Independent |
| Logical Entity Name | AdEnroll_Proxy |
| Default Table Name | AdEnroll_Proxy |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| AdEnroll_Proxy Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
AdEnroll_ProxyID |
BIGINT | NO | ||
| TableName | VARCHAR(255) | NO | ||
| RecordID | INTEGER | NO | ||
| OldAdAttStatID | INTEGER | NO | ||
| NewAdAttStatID | INTEGER | NO | ||
| OldAdShiftID | INTEGER | NO | ||
| NewAdShiftID | INTEGER | NO | ||
| OldAdProgramVersionID | INTEGER | NO | ||
| NewAdProgramVersionID | INTEGER | NO | ||
| OldAdSapStatusID | INTEGER | YES | ||
| NewAdSapStatusID | INTEGER | YES | ||
| OldAppRecDate | DATETIME | YES | ||
| NewAppRecDate | DATETIME | YES | ||
| OldEnrollDate | DATETIME | YES | ||
| NewEnrollDate | DATETIME | YES | ||
| OldGradDate | DATETIME | YES | ||
| NewGradDate | DATETIME | YES | ||
| OldOrigGradDate | DATETIME | YES | ||
| NewOrigGradDate | DATETIME | YES | ||
| OldExpStartDate | DATETIME | YES | ||
| NewExpStartDate | DATETIME | YES | ||
| OldReentryDate | DATETIME | YES | ||
| NewReentryDate | DATETIME | YES | ||
| OldMidDate | DATETIME | YES | ||
| NewMidDate | DATETIME | YES | ||
| OldExternBeginDate | DATETIME | YES | ||
| NewExternBeginDate | DATETIME | YES | ||
| OldSaBillingMethodID | INTEGER | YES | ||
| NewSaBillingMethodID | INTEGER | YES | ||
| Comment | VARCHAR(255) | YES | ||
| UserID | INTEGER | NO | ||
| ModFlag | CHAR(1) | YES | ||
| OldAdCatalogYearID | INTEGER | YES | ||
| NewAdCatalogYearID | INTEGER | YES | ||
| OldExpectedHoursPerWeekFOrExternship | NUMERIC(9, 2) | YES | ||
| NewExpectedHoursPerWeekFOrExternship | NUMERIC(9, 2) | YES | ||
| OldExpectedCreditsPerTerm | NUMERIC(7, 2) | YES | ||
| NewExpectedCreditsPerTerm | NUMERIC(7, 2) | YES | ||
| OldStartDate | DATETIME | YES | ||
| NewStartDate | DATETIME | YES | ||
| OldCreditsReq | NUMERIC(7, 2) | YES | ||
| NewCreditsReq | NUMERIC(7, 2) | YES | ||
| OldHoursReq | NUMERIC(9, 2) | YES | ||
| NewHoursReq | NUMERIC(9, 2) | YES | ||
| OldLinkedSAPEnrollId | INTEGER | YES | ||
| NewLinkedSAPEnrollId | INTEGER | YES | ||
| OldNSLDSWithdrawalDate | DATETIME | YES | ||
| NewNSLDSWithdrawalDate | DATETIME | YES | ||
| DateAdded | DATETIME | NO |
| AdEnroll_Proxy Keys |
| Key Name | Key Type | Keys |
| AdEnroll_Proxy_AdEnroll_ProxyID_U_C_IDX | PrimaryKey | AdEnroll_ProxyID |
| AdEnroll_Proxy Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| AdEnroll_Proxy Check Constraints |
| Check Constraint Name | CheckConstraint |
| AdEnroll_Proxy Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.AdEnroll_Proxy |
NO | |||
| Physical (Microsoft SQL Server) dbo.AdEnroll_Proxy |
NO |
| AdEnroll_Proxy Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Academic Records |
| AdEnroll_Proxy Data Movement Rules |
| Name | Type | Rule Text/Value |